Week 2 — Dashboards & Visualisation
Week 2 — Dashboards & Visualisation
Sessions 3–4 · Mondays & Thursdays
Welcome back! This page contains the full Week 2 breakdown, exercises, and downloadable resources. Bookmark this page — you’ll need it again before each Week 2 session.
Learning Outcomes
By the end of Week 2, you will be able to:
- Design and build interactive M&E dashboards using Power BI / Google Looker Studio
- Use AI to write DAX formulas, calculated fields, and custom metrics
- Create programme performance trackers and indicator monitoring dashboards
- Build geographic / heat-map visualisations for field programme data
- Apply data storytelling principles to guide stakeholder decisions
- Set up automated dashboard refresh from live data sources
Session 3 — Building AI-Assisted Dashboards
Monday · 7:00 PM EAT
- Power BI & Looker Studio with AI co-pilot
- AI-generated DAX / calculated fields
- Indicator tracking dashboard — built live in-session
- Automated data refresh setup
📂 Session 3 materials: Slide deck (PDF) · Dataset for live exercise (CSV) · Dashboard starter template (.pbix)
Session 4 — Data Visualisation & Storytelling
Thursday · 7:00 PM EAT
- Chart selection framework for M&E data
- Geographic visualisation for field programmes
- Data storytelling structure for non-technical stakeholders
- Stakeholder-specific dashboard layouts
📂 Session 4 materials: Slide deck (PDF) · Geographic data sample (CSV) · Looker Studio template link
Practical Exercises
Exercise 2.1: Build a programme performance dashboard from the provided dataset — include KPI cards, trend lines, and a geographic component — in under 45 minutes.
Exercise 2.2: Transform a 3-page data table into a one-page visual story using AI-guided chart selection and narrative framing for a donor audience.
Need help before the session?
Post your question in the WhatsApp group, or email vmandela99@gmail.com.
➡️ Continue to Week 3 (separate password required)